package com.jinmdz.fmis.dao.dao;

import com.jinmdz.fmis.dao.model.funeral.FamilyAgentItem;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 承办人Dao
 *
 * @author LiCongLu
 * @date 2020-02-06 13:58
 */
public interface FamilyAgentDao {

    /**
     * 按照业务编码获取未删除逝者承办人信息
     *
     * @param businessCode 业务编码
     * @return
     * @author LiCongLu
     * @date 2020-02-06 13:52
     */
    @Select(" select id,business_code,agent_type,agent_unit_name,agent_name,agent_gender_code,certificate_type_code,certificate_no" +
            ",agent_relation,mobile_phone,other_phone,address,remark,version " +
            " from family_agent where business_code = #{businessCode} and deleted=0 limit 1 ")
    FamilyAgentItem getFamilyAgentByBusinessCode(@Param("businessCode") String businessCode);

}
